CREATE TABLE [dbo].[FS_Employ]
(
[fdStudNo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdUnitName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Employ_fdUnitName] DEFAULT (''),
[fdUnitContact] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Employ_fdUnitContact] DEFAULT (''),
[fdUnitTel] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Employ_fdUnitTel] DEFAULT (''),
[fdUnitAdd] [nvarchar] (300) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Employ_fdUnitAdd] DEFAULT (''),
[fdUnitType] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Employ_fdUnitType] DEFAULT (''),
[fdUnitPlace] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Employ_fdUnitPlace] DEFAULT (''),
[fdCreateAt] [datetime] NOT NULL CONSTRAINT [DF_FS_Employ_fdCreateAt] DEFAULT (getdate()),
[fdYear] [int] NOT NULL CONSTRAINT [DF_FS_Employ_fdYear] DEFAULT ((2006))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FS_Employ] ADD CONSTRAINT [PK_FS_Employ] PRIMARY KEY CLUSTERED  ([fdStudNo]) ON [PRIMARY]
GO
